Release 10.1A: OpenEdge Data Management:
DataServer for ODBC

Binding with connection and startup parameters

Binding settings determine how data is pulled from the data source by the DataServer. When binding is turned on, query results are copied directly into the DataServer’s memory, eliminating the need to do post-query calls to retrieve the data. When binding is not enabled, queries run independent of the data retrieval, and subsequent calls to the data source are required to retrieve the data.

The default setting is to use binding for both NO-LOCK and EXCLUSIVE-LOCK queries. You can override the default using the -Dsrv BINDING,n connection parameter. The syntax is as follows:

Syntax

-Dsrv BINDING,n;

Table 4–3 describes the BINDING options that you can specify with the -Dsrv parameter.

Table 4–3: Connection BINDING options

BINDING value	Description
0	Indicates that binding is not enabled at all.
1	Use binding for NO-LOCK queries only.
2	Use binding for EXCLUSIVE-LOCK queries only.
3	Use binding for both NO-LOCK and EXCLUSIVE-LOCK queries. This value is the default.